Software of the Month Club (Business) 1997 September #242

home *** CD-ROM | disk | FTP | other *** search

/ Software of the Month Cl…ness) 1997 September #242 / Software of the Month Club - Business Shareware (September 1997).iso / dos / biz / sercent / sc.pak / SC.DOC < prev next >

Wrap

Text File | 1997-08-10 | 61.6 KB | 1,394 lines

Copyright G.L. Rose 1997 LEGAL: Since computer programs are inherently complex, and may not be completely free of errors. ROSEWARE will not be liable for direct, indirect, special, incidential or consequential damages arising out of the use of the program or documtation. IN NO CASE WILL ROSEWARE'S LIABILITY EXCEDE THE AMOUNT OF THE PURCHASE PRICE. If errors are found ROSEWARE will correct them in a timely manner at no cost. If for any reason during the first 90 day's after registering you become dissatified with the program, your purchase price will be completely refunded. ****************************************************************************** Moving right along............ Service Center quick start: Service Center is designed to run in a DOS environment. Go to DOS, from the C:> Type A:INSTALL and press the enter key. After installing, type "cd\sc" (no quotes) press enter. Type "SCSETUP", press enter. From the menu select "Install Files". this will create all the necesary files. Now choose "Select Printer". Using the up or down arrow keys, find your printer and press enter. Answer yes to test the printer. If it prints compressed and normal, everything is ok. If not select another printer similar to your printer. Quit the setup program. *----------------------------------------------------------------------------- Type "SC", press enter. Select "System Information". select -> "Company Information" ┌───────────────────────────────────────────────────┐ │ Name: │ │ Address: │ │ City: │ │ State: │ │ Phone: │ │ Zip: │ │ Monitor: │ │ Allow Sound (Y-N): │ │Allow Neg Inventory (Y-N): │ │ Tax Labor (Y-N): │ │ Primary Shop Rate/Hour: │ │ Secondary Shop Rate/Hour: │ │ Normal Terms: │ │ Discount Percent: │ │ Password: │ └───────────────────────────────────────────────────┘ Name: Your company name Address: Your address City: Your city State: Your state Phone: Your phone number (including area code) Zip: Your zip code Monitor (C-M): If you have a color monitor, "C" else "M" Allow Sound (Y-N): New user "Y", else "N" Allow Neg Inventory (Y-N): "Y" allows inventory levels to drop below zero Tax Labor (Y-N): "N" indicates labor is non taxable "Y", taxable Primary Shop Rate: Your primary shop rate Secondary Shop Rate: Secondary shop rate, if none use same as primary Normal Terms: Your customers normal terms Discount Percent: If discounts allowed, the normal percent discount Password: If new user use blank otherwise any thing desired Note: to add a disclaimer/warranty message, press F4. There are 10 lines of 65 characters. This will print on the lower left portion of the invoice. F5 will bring up the invoice message screen. There are 5 individual lines of 50 characters per line. Only one line will print at a time. While invoiceing you are able to select which line desired. Invoice messages are printed on the bottom of the invoice. *----------------------------------------------------------------------------- Select -> "Profit Levels & Fees" ┌─────────────────────────────────────────────────────┐ │ Customers at Level 1: │ │ Customers at Level 2: │ │ Customers at Level 3: │ │ Customers at Level 4: │ │ │ │ Percent to charge for shop supplies: │ │ Maxium charge for shop supplies: │ │ Environmental Fees: │ └─────────────────────────────────────────────────────┘ Customers at level 1: Highest level of profit Customers at level 2: Second level of profit Customers at level 3: Third level of profit Customers at level 4: Lowest level of profit Percent to charge for shop supplies: Normaly 2% to 2.5% Shop supplies are calculated on the total invoice including labor. (see note) Maximum charge for shop supplies: Normaly $10.00 to $20.00. Environmental Fees: Normaly $2.80 (see note) Note: Shop supplies and environmental fees will NOT be automatically added to invoices. They are manualy added and can be edited at any time. Shop supplies are assumed taxable. Environmental fees, non taxable *----------------------------------------------------------------------------- Select -> "Local Sales Tax": ┌───────────────────────────────────────────────┐ │ City Name : │ │ Tax Rates │ │ Salestax: │ │ State Tax Discount: Percent │ │ Environmental Discount: Cents Ea │ └───────────────────────────────────────────────┘ City Name: Your city Salestax Rate : Your state tax rate State Tax Discount: State tax discount rate (if applicable) Environmental Discount: Environmental discount (if applicable) Note: State tax are PERCENTS, environmental fees are CENTS *----------------------------------------------------------------------------- Select -> "Customers" Select -> "Add" Enter any customer information (perhaps yourself). Some special notes. If the customer has a tax id number, Service Center assumes this is a NON TAXABLE CUSTOMER. It is not necessary for customers to have a vehicle to invoice, however for our first customer lets enter one. When you get to the, Vehicle (Y-N) answer "Y" and save. You are now at the vehicle portion of the customer screen. Enter the vehicle information, save and press Esc to exit. Quit back to the Main Menu. *----------------------------------------------------------------------------- Select -> "Inventory" Add any item desired. After saving press Esc back to the Main Menu. *----------------------------------------------------------------------------- Select -> "Transactions", Select -> "Invoice Menu", Select -> "Create Invoice" Press F1 for general help. Thru out the program, pressing AltF1, displays help on each field. Press "I", for Invoice ("W"-Warranty "E"-Estimate) Who is the customer, Press F8-Select the customer you added. Select the Vehicle for this customer. What is the RO number (leave blank for now, its optional) Date, if ok simply press enter Now press F9, HiLite the inventory item you added and press enter. What is the quantity? Press F4, enter anything desired for the labor portion for this invoice. Press Esc. Press AltP (hold down the Alt key and press "P") Pay this invoice. Press Esc Save and print. Thats it! SC.EXE invoicing,customers,inventory,vendors,etc... PSC.EXE all print reports SCSETUP.EXE misc stuff, printers, query, back up, restore, etc.... AUTO.TXT vehicles SC.DOC this file PRINTERS.DBF all the printers we support SCHIST.EXE history Important: I recomend you enter good information (not junk). In the event you purchase Service Center, it can be registered over the phone with a single key stroke. While in the DEMO mode, approximately 50 invoices and be created. Once Service Center has been registered you will NOT have the option of changing the name and address. In the future should you want to change this information. Call (or email), its no big deal. PERSONAL: My name is... Jerry Rose (57 years old) 3201 Stanford Plano, TX 75075 (972)599-2477 Along with writing software, I am in the restaurant business (21 years). My restaurant makes my living for me. Writing software has become a second business for me that I enjoy. I believe I have priced Service Center reasonably and affordable. The last thing I want is a dissatisfied customer. If for any reason you should become dissatisfied with my software (for the first 90 days) I will return your purchase price. The name of my restaurant is "TACO DELITE" (972)424-5419. It is ok to call me there however should it be during my lunch period I will probably have to call back. I would like to thank my wonderful wife (Wanda Jean), who has allowed me many of hours developing this software. GENERAL: All thru the program, if you get into trouble, press Esc and you will back up one level. On the Main Menu Screen, Esc is disabled. In all the popup boxes pressing Alt L will give you a lookup option. Pressing Alt plus any letter key means HOLD DOWN THE ALT KEY AND WHILE HOLDING DOWN PRESS THE APPORIATE LETTER AND RELEASING. On almost all screens pressing PgUp or PgDn will move you up or down the file. In most cases any critical information will be dispalyed at the bottom of the screen. Pressing F1 will bring up help. AltF1, specific help for each field. *----------------------------------------------------------------------------- CUSTOMERS: ADDING a new cutomer: Select "Customers" from the Main Menu Select "Add" from the customer menu As new customers are added they are assigned a number automatically. Enter: ┌──────────────────────────────────────────────────────┐ │ Code: │ │ Name: │ │ Address: │ │ City: │ │ St: │ │ Zip: Work │ │ Phone: ( ) - ( ) - │ │ Priceing Level: │ │ Terms: Discount: │ │ Tax Id Number: │ │ Vehicle (Y-N): │ ├──────────────────────────────────────────────────────┤ ├──────────────────────────────────────────────────────┤ │ Vehicle: │ │ License: Eng: │ │ Mileage: Vin: │ └──────────────────────────────────────────────────────┘ a) Priceing Level When you set up Service Center in the "Profit Levels and Fees" you established the four levels of profit for your parts sold. This level determines at what level of profit to use for this customer. Normaly level 1 would be the highest, 4 the lowest. If you are unsure as to what to do use, simply leave it a 1 and go on. b) Tax id Number If this field is left blank, Service Center assumes this is a taxable customer otherwise enter this customers tax id number. If you do not know the tax id number enter anything ( eg: "EXEMPT"). c) Vehicle If this customer has a vehicle, enter "Y" other wise "N". *-- EDITING Customers: Select "Customers" from the Main Menu Select "Edit" from the customer menu A window with all your customers will appear with the customer screen in the background. Hold down the alt key and press L then release. A popup box will appear asking "Look up what". Enter the name of the customer desired and press the enter key. Once the correct customer has been found hilite and press the enter key. Now you are on the customer editing screen. Simply type over the changes desired and save. Active keys are..... [F4] - Add Vehicle to Existing Customer [F5] - Edit Vehicles [F7] - Delete Customer and Vehicles (only if not invoiced) [F8] - Customer File [F10] - All Invoices for this Customer [AltF8] - Current Customer Credit Balance [AltF3] - Move Customer Information [CtrlF8] - Total Parts Purchased [AltO] - Print Work Order [AltV] - Look up any Customer Vehicle [PgUp] - Skip Back one Record [PgDn] - Skip Forward one Record CUSTOMER HISTORY: A box will appear with all your customers. Find the desired customer and press enter. A screen will appear with all of this customers information with the status of each invoice. Including what the vehicle mileage was at the time of this invoice. This feature is also while invoicing. At the bottom of the screen.. Total Purchases Total Payments Current Balance Total Invoices Hilite any invoice, press enter. 1) Payment history for this invice press enter again 2) All parts with vendor cross reference, quantity, selling price press enter again 3) all service connected to this invoice with cost and tech *----------------------------------------------------------------------------- CUSTOMER VEHICLES: Adding a vehicle to a new customer. Once a new customer has been added and saved, assuming you have answered "Y" to Vehicle. You will be on the "Vehicle Screen". Enter: Vechile : (a brief description eg: "HONDA PASSPORT 1994") Liscense: Mileage : (may be changed while invoicing) Eng : (engine size) Vin : Save the information and Service Center will assume you want to add another vehicle. If no other vehicles are needed at this time press Esc and you will be back at the "Customer Screen" Adding a vehicle to an existing customer. Refer to "Editing Customers" Find the desired customer and press F4, add the new vehicle. When finished press Esc to quit. *-- Editing customer vehicles: Find the desired customer and press F5. A box will appear with all this customers vehicles. Find the desired vehicle and press enter. Type over and changes necessary and save. When finished press Esc to quit. If you delete a vehicle that has been invoiced "UNKNOWN" will be used. *----------------------------------------------------------------------------- EMPLOYEES: ADDING a new employee Select "Employees" from the Main Menu Select "Add-Edit Employees" from the "Employee Menu" ┌────────────────────────────────────────────────────┐ │Employee Id Department │ │First Name Last Name │ │Street │ │City State Zip │ │Phone Social Security Number │ ├────────────────────────────────────────────────────┤ │Hire Date │ ├────────────────────────────────────────────────────┤ │(H)ourly-(S)alaried Payroll Frequency │ ├────────────────────────────────────────────────────┤ │Married (Y-N) Number of Dependence │ ├───────────────────────────┬────────────────────────┤ │Insurance │Percent Commission │ │Misc │ │ │Additional Wh │Rate │ └───────────────────────────┴────────────────────────┘ Enter a unique code for this employee (eg: 0100 or "JR") Department (eg: tech,office,mgr) First Name Last Name City State Zip Phone SS Number Hire Date (Approximately the date this employee was hired) Salaried (Normaly for repair shops enter "H" for hourly) Payroll Frequency (How often payroll is issued, weekly, semimonthly, etc) Married Dependents Insurance - (enter zero) Misc (enter zero) Wh (enter zero) Percent Commission (see note "a") Rate (see note "b") a) Percent Commission: If this tech works on a percent basis Service Center will use this percent in calculating the profit on the labor portion of each invoice. b) Rate: Rates should be entered as hourly. If a tech gets a hourly rate plus a percent. The percent will be used exclusively. Service Center assumes that if any thing is entered in the percent field, you want to use this over any hourly rate. Simply put, if a tech is geting a percent enter zero for the rate. Normaly you will not have a percent and hourly rate. *-- EDITING Employees Select "Employees" from the Main Menu Select "Add-Edit Employees" from the "Employee Menu" Press Alt E, (hold down the Alt key and press E) and find the employee desired. Once found press enter and simply type over the exisitng information and save. *----------------------------------------------------------------------------- INVENTORY: ADDING Inventory: Select "Inventory" from the Main Menu Select "Add-Edit" from the Inventory Files Menu ┌───────────────────────────────────────────┐ │ Item Code: vendor code │ │ Primary Group: eg:starters │ │ Secondary Group: eg:ford │ │ Description: description of part │ │ Vendor: supplier │ │ Units: ea,cs,ft,lb,hr │ │ Current Level: quantity on hand │ │ Build To: quantity to keep │ │ Current Cost: current cost │ │ Last Cost: last paid │ │ Selling Price: user selling price │ │ Taxable (Y-N): taxable Ytd: │ └───────────────────────────────────────────┘ ┌───────────────────────────────────────────┐ │ 0.00 0.00 0.00 0.00 │ └───────────────────────────────────────────┘ a) Refering back to "Profit Levels and Fees", you entered the desired levels of profit. Service Center now will calculate the selling price for this item. As you were entering customers you also entered their level. Now as you invoice each customer their cost of parts will be calculated on whatever level you have entered. Not to worry, as you are invoicing you will have the opportunity to overide any selling price. The formula to calculate profit is.... cost / (1.00-Level of profit) Profit level = 25% Cost = 1.00 1.00-.25 = .75 1.00/.75 = 1.33 selling price 1.00/(1.00-.25) = 1.33 b) If a selling price is entered. No calculated price will be used. All levels will have the same selling price. There are 2 methods in calcualting the selling price of any item. 1. You enter the selling price desired or...... 2. Service Center will calcualte selling price automatically Remember you will ALWAYS have the opportunity to overide any selling price while invoicing. You are in complete control as to whats going on! Active keys are..... [F2] - Add Vendor [F4] - Vendor File [F9] - Parts by Vendor Code [AltF1] - Field Help [AltF9] - Parts by Description [CtrlF9] - Parts by Group *-- EDITING Inventory: Select "Inventory" from the Main Menu Select "Add-Edit" from the Inventory Files Menu Press F9, your inventory file will appear. Press Alt L (hold down the Alt key and press L). Enter the Vendor code and press enter. Once the part has been found, press enter and type over any changes desired and save. If you delete a part that has been invoiced, 'DELETED PART' will be used for the description. Active keys are... [F2] - Add Vendor [F4] - Vendor File [F7] - Delete Select Part [F9] - Parts by Vendor Code [AltF1] - Field Help [AltF9] - Parts by Description [AltI] - Usage by Customer [AltT] - Usage by Month [PgUp] - Skip back one Record [PgDn] - Skip forward one Record [CtrlF9] - Parts by Group *-- VIEW DELETE INVENTORY: Select "Inventory" from the Main Menu Select "View-Delete-Order" from the Inventory Files Menu There are four different sort orders to look at your inventory file. 1. Description 2. Code 3. Vendor 4. Group Select whatever sort order desired. Now look up whatever part and .... 1. Delete 2. Recall 3. Print bar codes 4. Enter quantity on hand 5. Change the cost 6. Look up parts Actualy not much going on here. *----------------------------------------------------------------------------- VENDORS: ADDING Vendors: Select "System Information" from the Main Menu Select "Vendors" from the System Information Menu Each vendor must have a unique code. For example "Roseware" might be RW. Other than the vendor code, the rest of the information is obivious. The contact is whoever you would normally talk to when ordering. *-- EDITING Vendors: Select "System Information" from the Main Menu Select "Vendors" from the System Information Menu Type in the vendor code and press enter, type over whatever changes necessary and save. If the vendor code is unknown, press F4, find the vendor and press enter. Again type over any changes and save. *----------------------------------------------------------------------------- JOBS/SERVICES: Here you can create repetitious jobs. Enter the unique job code, for example LOF might be the code for "Lube oil and filter". You would enter LOF for the job code and "Lube oil and filter" for the job. Now enter the time allowed for this job. The program will calculate the selling price for the labor portion or you can enter whatever selling price desired. Enter the parts connected with this peticular job. In the future whenever this job comes in, on the invoice screen you will have the option of calling up this job and complete a whole invoice with a single key stroke. If this seems to complicated forget this one and go on. As you learn the program this will become a handy tool. Remember to press AltF1 for help on each field, this might help. ┌───────────────────────────────────────────────┐ │Code │ │Job │ │Time <- Current Shop Rate │ │Cost <- Current Shop Rate * Time │ ├───────────────────────────────────────────────┤ │Part # Quan Description Sell Ext│ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ └───────────────────────────────────────────────┘ Total Invoice -> 0.00 *----------------------------------------------------------------------------- VEHICLES: ADDING Vehicles: Select "Vehicles" from the Main Menu Select "Add" from the Vehicles Menu Enter the make,model,year of the any vehicle. The part would be any part connected to this vehicle. For example: Make...........FORD Model..........TAURUS, SABLE W/V6 Year...........86-91 Part...........AXOD (this would be the transmission for this vehicle) With this in mind the same could be true with starters, carburators, etc... The programs comes with approximately 288 vehicles with transmissions. *-- EDITING Vehicles: Select "Vehicles" from the Main Menu Select "Edit" from the Vehicles Menu A popup list of the vehicles will appear. Hilite the desired vehicle and press enter. Type over the necessary changes and save. A neat feature is if you have the part connected to this vehicle in your inventory file, a box will display on the top portion of the screen displaying your cost, selling price quantity on hand, and description of the part connected. vendor and description of this part. MATCH: Enter the part to look up. a list of all the vehicles will appear with all the vehicles this part fits. This if for information purposes only. *----------------------------------------------------------------------------- WORK ORDER FORM: Select Transactions from the Main Menu Select Invoices from the Transactions Menu Select Add from the Invoice Menu From the Invoice Menu select "Work Order", select the customer and print. This will print a blank work order for this customer along with their vehicle information. This work order will follow the vehicle as its being repaired. From this work order an Invoice can be created. *----------------------------------------------------------------------------- INVOICE: ADDING Invoices: Select Transactions from the Main Menu Select Invoice Select Add ┌─────────────────────────────────────────────────────────┐ │ IEW Cust RO Date Inv │ ├─────────────────────────────────────────────────────────┤ │Code T Qty Units Description Price Amount │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ ├──────────────────────────────┬──────────────────────────┤ │ Vehicle │Tax Total │ ├──────────────────────────────┤Sales Tax │ │ │Non Tax │ │ │Total │ │ │Due │ └──────────────────────────────┘ While on the invoice screen pressing F10 will bring up a list of all prior invoices. While creating invoices this screen is for informational purposes only. An invoice is composed of two main sections, PARTS and LABOR. a) The first question. Is this an Invoice,Estimate, or Warranty. Enter: I for invoice, E for estimate, W for warranty b) CUSTOMERS AND VEHICLES: Now who is the customer. Enter the customer code, normally you would not know what this is. Press F8 for a list of all your customers. Now press Alt L (hold down the Alt key and press the letter L). Enter their name and press enter. Bingo there you are. Now press the Enter key. Once the customer has been found, a screen with all their vehicles will appear. Select the vehicle and press enter. You now have the customer and vehicle. ON THE FLY: Adding a customer or vehicle on the fly.... Customers along with many more options can be added or edited while on the invoice screen. To add a customer press F3, you will now be on the Customer add Screen, add the customer and vehicle, save press Esc and you will return to the invoice screen. Editing a customer or adding a vehicle on the fly.... First you must select the customer on the invoice screen press F3. Once selected press F3. You are now at the Customer Edit Screen. Make whatever changes needed or add another vehicle and save. When finished press Esc to return to the invoice screen. If a vehicle was added. Once you return to the invoice screen. Either press Alt M for a list of this customers vehicles and select the new vehicle or reselect the customer and select the added vehicle. Customer history.... While creating (or editing), press Alt H. This will take you to the Customer History screen. This screen contains every invoice this customer has had since day one. Editing vehicle mileage... The program always uses the mileage that was entered at the time you first entered it. Service Center keeps a record of vehicle mileage on each invoice. To change the vehicle mileage press F12 and enter the new mileage. Vehicle History..... Assuming this is a vehicle that has prior service, press F12 and all the previous service will display. Vehicle invoices..... Once a vehicle has been selected, press Alt V, all the invoices for this vehicle will display. c) RO: If you are using preprinted repair orders with RO numbers, enter the number here. Normaly this field would be blank. This field could be used to enter the customers PO number. If duplicate ro numbers are used, Service Center assumes continued invoices. While printing, if duplicate ro numbers are encountered, all invoies with the same ro will print. d) DATE: Enter the date, if todays date is ok, press enter and go on. e) PARTS: You are now at the first part to enter. Press F9 for a list of all your parts. Again you can press Alt L, enter the vendor code for the part, press enter and you are now on the part. Press enter and there it is on the invoice screen. Note, a "*" indicates taxable. It is important to note that if a non taxable customer is being invoiced, even if this part is taxable, no tax will be charged. What you are doing is selling taxable part to a non taxable customer. With this in mind it is better to keep tax id numbers for non taxable customers. Enter the quantity and if the price is ok simply press enter. If you want to sell the part for a different price than indicated, type over the displayed price. It is important to note that F9 displays parts by vendor code, Alt F9 is description. Continue adding all the necessary parts connected to this repair. You can up or down arrow at any time to make any corrections needed. NOTE: THERE ARE ONLY 13 LINES FOR PARTS. If more parts are needed you must create another invoice. To get around this possibly ypu might group some parts together. Possible refer back to ro numbers as a minor solution. Often times it would be neat if you knew who you purchased this part from. Press Alt F8 and enter whatever information you deem important. Now in the future if a problem developes with this part at least you will have some knowledge as to who (or what vendor invoice) to refer to. Possibly to get a credit or whatever. This information does not print on invoices. ON THE FLY: To add or edit any part on the fly, press F2. This takes you to the parts file. Add or edit any part, save, press Esc to return to the invoice screen. ON THE SCREEN: Addding a part on the invoice screen. If you enter a part that is NOT in your inventory file, Service Center assumes you want to add it on the invoice screen. The fist question. Is it taxable (Y/N). Enter quantity and description along with the selling price. This is a super fast way to create invoices. Once you save this invoice this part will be automaticaly added to your inventory file. Now to the drawbacks. Since we are not getting all the information about this part, only the part code, taxable, description and selling price will be saved. "OTF" will be used for group. At any time in the future you can edit this part and add the addition information if needed. Some times is will become important as to what a part was charged on prior invoices. Press Alt N, enter the part number and Service Center will display what you charged for this part the last time this vehicle was serviced. f) SERVICE OR LABOR: At any time press F4 this will take you to the labor portion of the invoice. The labor screen will overlay the parts screen. You will still have the opportunity to view the total invoice while adding labor. There are 9 lines of 60 characters per line to enter the description, cost, time, and tech. To exit the service screen, press Esc. To go back press F4. You can go back and forth as much as you like. NOTE TAX: If you charge tax for labor and tax is not be added to the labor. You have made a mistake in setting up the program. Press Esc, go back to the Main Menu, select System Information, Company Information and change "Tax Labor" to "Y" CODE: As you are entering labor (if a job code was entered), pressing Alt A will update your Jobs/Services file On future invoices this job can be recalled by pressing F2. This is a neat way to build your Jobs/Services file. Codes are not necessary to enter labor. If no code is entered this job will not be saved. All of this is optionable. Lets say you repair a lot of starters. Enter "RRS" for the job code. Enter "Remove and repair starter" for the description, .75 for the time, Service Center will calculate the price based on the shoprate you entered in System Information, or enter whatever price desired. Press Alt A to memorize the job. Now in the future when this same job comes in, press F2 then (Alt L) to look it up and recall it. Understanding that on any given job serveral mechanics could be working on this vehicle. Enter the tech for each line of labor performed. To change the shop rate. Press Alt F. Your secondary rate is now in effect. On the next invoice your shop rate will automaticaly be reset back to your primary rate. Actualy very seldom will you use your secondary rate. At a point in time one of my current customers thought this would be a great idea. To my knowledge no one has ever used it. I am considering completely removing it. No doubt someone out there in never never land will need it? (who knows) For now you can forget this one! When all the labor has been entered press Esc to return back to the invoice. g) PROFIT: If you have entered the cost of each part in your parts file along with the rate for your techs. Press Alt T. A box will appear displaying your total cost, dollar, and percent profit for parts and labor. h) SHOP SUPPLIES: Press F5 to add any shop supplies. If you have entered a percent in Company Information, shop supplied will be calculated for you. Either accept the displayed amount or enter any amount you want. Shop Supplies are not automaticaly added to any invoice. You must press F5 to add. shop supplied are displayed on the bottom right of the screen on the right of "Tax Total". If no shop supplies are added this will be blank. If you have entered the wrong price, press F5 again and reenter. Shop supplies are assumed taxable. Shop supplies WILL print on the invoice. i) ENVIRONMENTAL FEES: Press F6 to add environmental fees. Whatever value you entered in Company Information will display. These fees are not automaticaly added to invoices you must press F6. If you need to change simply enter any value desired. Environmental fees are displayed on the lower right portion of the invoice screen next to "Non Taxable" Environmental fees are assumed non taxable. Environmental Fees are printed on the invoice. j) PAYING AN INVOICE: Once an invoice has been completed, prior to saving. Press Alt P and enter the payment information. Not to worry, payments can be entered on the Edit Invoice Screen or Payments screen. k) SAVING: Once an invoice has been completed, press Esc. A list of options will display. Select whatever action desired and press enter. A runnig total of parts used (YTD usage) is updated each time a invoice has been saved. All these options are active on the invoice screen: F2 - Add or Edit Inventory F3 - Add or Edit Customers F4 - Add or Edit Service F5 - Add or Edit Shop Supplies F6 - Add or Edit Environmental Fees F7 - Zero out an Invoice or Estimate (editing only) F8 - Customer File F9 - Inventory File F10 - Invoice File F11 - Vehicle History F12 - Edit Vehicle Mileage AltH - Customer History AltI - Convert Estimate (editing only) AltM - Change Vehicle AltN - Last Price Charged for any Part AltO - Print Work Order (Creating Invoice) AltP - Pay Invoice AltR - Delete Single Line Item AltS - Change the Salestax Rate AltT - Profit Vs Cost AltV - Invoices for Selected Vehicle AltW - View Work in Progress AltF1 - Specific help on each field AltF2 - Predefined jobs (creating only) AltF3 - Change Customer (editing only) AltF5 - Work in Progress (On/Off) AltF6 - Payments History AltF8 - Cross Reference Parts to Vendor/Invoice (editing only) AltF9 - Inventory by Description CtrlI - Print Vehicle History CtrlF2 - Change Invoice Message l) ESTIMATES: Refering back to (a), enter "E". An estimate is created the same as a regular invoice with several execptions. Once saved, since no parts were actually sold your parts "YTD" will not be updated. There is no tax due along with no customer debt. you cannot pay estimates.Estimates can be converted to a normal invoice on the "Edit Invoice screen". m) WARRANTY: Refering back to letter (a), enter "W". You will be prompted to enter the original invoice to connect this warranty work to. Later on in the print reports we can print a report as to what tech did this job. This report will tell you who is creating the most of your warranty problems. For this reason it is important to enter the tech on the labor portion of the invoice. To some repair shops this is a big deal. n) HELP: At any time Press F1, if you press F1 again help will print. Remember at you can press Alt F1 to get specific help on each field. o) WORK IN PROGRESS: Alt W takes you to the Work in Progress Screen. Also from the Main Menu work in progress is avaliable. again press Alt W. There is is. Possibly the first thing for the day would be to print this file? When an invoice has been paid, it is marked completed. If you want to complete q job prior to being paid. Press Alt F5. This will either mark it completed or in progress. *----------------------------------------------------------------------------- EDITING INVOICES: Select Transactions from the Main Menu Select Invoices from the Transactions Menu Select Edit from the Invoice Menu a) FINDING INVOICES Enter the invoice number to edit. Most of the time you won't have a clue as to what the invoice number is. Press F10 for al list of all your invoices. The last 7 invoices will dispaly. Press Alt L, enter the invoice number and there you are. Press enter, then enter again. There it is. Another option is to press F8 for your custoemr file. Find the customer and press enter. Now all this customers invoices will display. Hilite the correct invoice and press enter. Normaly this is the easiest way to find invoices. Simply put, if you know the customer, finding invoices is snap. b) CHANGING CUSTOMERS If this invoice was for the wrong customer. Press Alt F3, enter the correct customer code, select the vehicle, press Esc and save. c) CHANGING VEHICLES Once the invoice is on the screen, press Alt M select the proper vehicle, press Esc and save. d) CHANGING THE TAX RATE Once the invoice is on the screen, press Alt S. Enter the new rate and save. e) CONVERTING ESTIMATES TO INVOICES Once the invoice is on the screen, Press Alt I and save. f) ZERO OUT AN INVOICE Once the invoice is on the screen, Press F7 to zero out. Once an invoice has been zeroed out, it is best not to reuse it. g) PAYMENT HISTORY Assuming this invoice has been paid. Press Alt F6 and all the payments for this invoice will display. h) SAVING EDITED INVOICES When all the corrections have been made. Press Esc for a list of options. Hilite the apporiate selection and press enter. i) EDITING A PAID INVOICE This is somewhat complicated. First you must unpay this invoice by going to the Edit Payments Screen. Zero out the payment. Now go back to the invoice screen an call up this invoice. Once the corrections have been made, you now can save it (it is no longer a paid invoice). Now assuming there really is no debt concerning this invoice. Go back to the Edit Payments Screen find the payment and enter the amount paid again. This is explained more in detail in the PAYMENTS section of this document. One of the reasons for this complication is to keep other people from messing up your program. Just remember once an invoice has been paid for the most part editing is not allowed. j) DELETING INVOICES This is not allowed. Invoices can be moved to History. Don't concern yourself with history at this time. Its not important. History will be explained later. You should have years of use before history comes into play. k) ADDING ADDITIONAL PARTS TO INVOICES Call up the invoice, press enter until your cursor is at the "What line to edit". Enter the line number. Now enter the part and whatever information needed. l) EDITING PARTS Call up the invoice. Press enter until al the "what line to edit". Enter the line number and edit away. m) EDITING OR ADDING SERVICE Once the proper invoice has been found and on the screen. Press F4 add or edit and line necessary. n) DELETING A SINGLE LINE ITEM Call up the invoice. Press enter until at the "what line to edit". Enter the line number. Press Alt R to remove. o) PAYING INVOICES Once the invoice is on the sreen, press Alt P and pay. If prior payments have ben made, you cannot pay invoices in the Edit Invoice Screen. They must be paid in the "Add Payments Screen". *----------------------------------------------------------------------------- PAYMENTS Adding Select Transactions from the Main Menu Select Payments from Transactions Menu Select Add Enter the invoice number to pay. Again you probably don't have a clue as to what the number is. Press F10 for a list of all your invoices. Press Alt L to look up the invoice, hilite and press enter. Actualy it is eaiser if you press F8 for the customer file, find the customer, press enter and all their invoices will display. Select the proper invoice and press enter. The invoice information will dispaly on the upper portion of the screen along with this customers total outstanding balance including the age of the invoice. If this invoice has had prior payments made, the current balance owed will display along with any discounts. You enter the amount of the payment, any additional discounts. How paid refers to cash, credit card, etc. Reference would be the check number or credit card number. Employee refers to who took the money. In Daily Sales in the print reports we print a report that references this information. *-- Editing Select Transactions from the Main Menu Select Payments from Transactions Menu Select Change Refer to adding payments as to how to find the invoice. Once the invoice has been selected. All the payments will display in the upper right portion of the screen. Using the up or down arrow keys hilite the payment to change and press enter. Type over any changes necesary and save. *----------------------------------------------------------------------------- SCSETUP.EXE Data Base Query: Service Center offers a number of canned reports. There may come a time when this does not meet your needs. Here comes the "Query". You can build queries of mind boggling complexities. Here is an example of a very simple query: Select Query Choose from: SELECT CUSTOMER.DBF, press enter Press F10 to continue Now press F4 to select all the fields Press F10 to continue SORTED by Select CUSTNAME, press enter Press F10 to continue WHERE Down arrow to CUSTCITY, press enter, "IS" is hilited, press enter, now "EQ" is hilited, press enter. CUSTCITY is at the bottom of the screen. Enter your city (make sure your Caps Lock key is on, everything must be in capitol letters), press enter Press F10 Bingo......there are all the customers sorted by name for the city you are in. Now just think for a second. If you wanted to you could actualy get all the customers for a peticular zip code, who was invoiced for over $500.00, and only had FORD automobiles, and have not paid their bill. To get a query of this complexcity would take some doing, however think of the possibilities at your fingertips. When time permits, play in here, you can do no damage. Refer to the TECHINICAL portion at what each data base contains. GRAPH: First, you must have at least a VGA color monitor. If not forget it. Moving right along. We will gather some information. Now a screen with all your sales along with the date will display. Press space bar to select what days to graph. Its best to graph a month at a time. Select any given month by pressing the space bar and selecting the appropriate days. Once the dates have been selected, press enter. A screen will appear with a lot of complicated looking information. For now accept the values displayed by pressing enter thru each field. There is your graph. Two values are diplayed. Service and parts for the days selected along with the percent of both. Go back the the previous screen by pressing enter twice, this time change...... "Spaceing" to 100 and go on thru. press enter twice change...... "Percent" to 50 and go on thru Keep entering different values in the fields and you will quickly see what happens. Remember this graph is NOT an exact science of your business, only a general snapshot. For grins try doing a weekly pie chart, its fun. BACK-UP FILES: Needless to say, backups are very important. Roseware recomends backing up at least once a week. Since disks can go bad, consider using different sets of disks for your backups, changing frequently. Now to the actual backup. Enter a disk in to your floppy drive. Enter drive letter to back up to....., press enter twice. Thats it. As time goes you might need several disks for backing up. RESTORE FILES: A word of CAUTION! When you restore, you overwrite the existing information with the restored information. For this reason a password is required prior to restoring. The password is 123456. Unless you have had a total disk failure, I would not restore files. This is one you might consider calling prior to executing. Lets talk about it. One more word of caution, I would not give out the password. Accidents happen. SELECT PRINTER: Selecting this option will take you to a screen of all the printers. Using the Up or Dn arrow keys find your printer and press enter. Answer "Y" to "Test printer". Serveral lines of compressed and normal print will print. If compressed is not being printed, select another printer close to yours. Keep trying until the print is correct. The defalut is "Epson Fx 80". Service Centers comes with "PRINTERS.DBF" that contains approximately 1160 printers. HISTORY: As time goes by, you will have huge amounts of information collected into your program. Many times we will processing all this information. You do not have to be a computer guru to figure out there will come a day when your program will slow down to a crawl. Here comes HISTORY. As a general rule I would say you do not have to concern your self with HISTORY for at least 2 or maybe 3 years. Lets say you have been using Service Center for 2 years with January being your first month. What our objective is to move all the PAID invoices for January of the first year. Select History, press enter Select January, press enter Select year, pres enter All the PAID invoices for this month and year will display. Using the space bar, check off the desired invoices to move to history. Most of the time it will be all of them. You will be prompted to confirm what you are doing. Remember, once records have been moved to history, they cannot be recalled back into Service Center. Assuming you continue...all the checked invoices will be transfered to your history data bases and deleted from Service Center's data bases. Not to worry. Once invoices have been moved to history, they can be viewed or printed. Records are moved into the history file month by month. After a time, records can be permantly removed from history. In a nut shell records accmulate into Service Center. After a period of time moved into history then permantely removed. This whole process can take years. INSTALL FILES Service Center does not come with data bases or the index files necessary to operate. Here is where they are created. If this option is selected and all the data bases are already created, nothing happens. When you first start using Service Center this is the very first place ypu have to go. KILL FILES: DANGER...DANGER...DANGER Here you can delete records from almost all the data bases. If you have just purchased or are demoing Service Center, and have entered a bunch of usless information. Here is where to go and clean up all the junk and start over. A password is required, 123456. As a word of CAUTION, once records have been removed, THEY CANNOT BE RECALLED!. Make sure you understand whats going on prior to running this routine. Possibly consider calling Roseware for help. CHANGE AREA CODE: Enter the area code to change from then enter the area code to change to. No big deal... *----------------------------------------------------------------------------- TECHINICAL: Requirements 286 mono or color (386 better) approximately 500 k of free memory Files in config.sys set to at least 51 If you get a message "Not enough memory". Remove the "NOEMS" statement in your config.sys. Service Center uses extended memory. DATA BASES: SYSTEM.DBF PARTS.DBF CUSTOMER.DBF VEH.DBF VENDOR.DBF INVOICE.DBF INVNODE.DBF PAYMENTS.DBF SERVICE.DBF JOBS.DBF ITMNDX.DBF EMPLOYEE.DBF JOBPART.DBF PRINTERS.DBF (SUPPLIED) DATA BASE STRUCTURE FIELD NAME , TYPE AND LENGTH, NUMERIC LENGTH AND NUMBER OF DECIMALS SYSTEM.DBF.....Company and global information ---------- STORE 'NAME C40 ' TO FIELD1 && COMPANY NAME STORE 'ADDRESS C40 ' TO FIELD2 && ADDRESS STORE 'CITY C20 ' TO FIELD3 && CITY STORE 'STATE C2 ' TO FIELD4 && STATE STORE 'ZIP C10 ' TO FIELD5 && ZIP CODE STORE 'PHONE C10 ' TO FIELD6 && PHONE STORE 'MONITOR C1 ' TO FIELD7 && COLOR OR MONO STORE 'PRINTER C30 ' TO FIELD8 && PRINTER STORE 'STATETAX N7 4' TO FIELD9 && SALES TAX RATE AS A PERCENT STORE 'DISCOUNT N7 4' TO FIELD10 && NORMAL CUSTOMER DISCOUNT STORE 'SOUND L1 ' TO FIELD11 && SOUND STORE 'TERMS C15 ' TO FIELD12 && NORMAL CUSTOMER DISCOUNT STORE 'PASSWORD C10 ' TO FIELD13 && PASSWORD STORE 'ISDEMO L1 ' TO FIELD14 && DEMO MODE STORE 'CDISCOUNT N6 3' TO FIELD15 && SALES TAX DISCOUNT STORE 'TDISCOUNT N7 4' TO FIELD16 && ENVIRONMENTAL DISCOUNT STORE 'NEGINV L1 ' TO FIELD17 && ALLOW NEGITIVE INVENTORY STORE 'LEVEL1 N6 3' TO FIELD18 && PROFIT MARGIN-LEVEL 1 STORE 'LEVEL2 N6 3' TO FIELD19 && PROFIT MARGIN-LEVEL 2 STORE 'LEVEL3 N6 3' TO FIELD20 && PROFIT MARGIN-LEVEL 3 STORE 'LEVEL4 N6 3' TO FIELD21 && PROFIT MARGIN-LEVEL 4 STORE 'SHOPPER N5 2' TO FIELD22 && PERCENT SHOP SUPPLIES STORE 'SHOPMAX N5 2' TO FIELD23 && MAXIMUM SHOP RATE STORE 'SHOPRATE N5 2' TO FIELD24 && CURRENT SHOP RATE STORE 'SHOPRATE2 N5 2' TO FIELD25 && SPARE, NOT USED STORE 'OLABOR L1 ' TO FIELD26 && OVERIDE LABOR STORE 'TAXLABOR L1 ' TO FIELD27 && TAX SERVICE ? STORE 'ENVIROFEE N5 2' TO FIELD28 && ENVIRONMENTAL FEES STORE 'FAX C10 ' TO FIELD29 && FAX NUMBER PARTS.DBF.....Parts file --------- STORE 'PARTID C11 ' TO FIELD1 && UNIQUE PART ID NUMBER STORE 'PARTTEXT C35 ' TO FIELD2 && TEXT STORE 'PARTCODE C10 ' TO FIELD3 && GROUP STORE 'PARTCODE2 C10 ' TO FIELD4 && GROUP STORE 'PARTSELL N8 2' TO FIELD5 && OVERIDE SELLING PRICE STORE 'PARTCOST N8 2' TO FIELD6 && SIZE STORE 'PARTLCOST N8 2' TO FIELD7 && LAST COST STORE 'PARTUNIT C2 ' TO FIELD8 && HOW SOLD STORE 'PARTVEND C5 ' TO FIELD9 && VENDOR STORE 'PARTTAX L1 ' TO FIELD10 && TAXABLE ? STORE 'PARTBUILD N4 0' TO FIELD11 && BUILD TO LEVEL ? STORE 'PARTOH N4 0' TO FIELD12 && CURRENT LEVEL OF INVENTORY STORE 'PARTYTD N9 2' TO FIELD13 && TOTAL UNITS SOLD CUSTOMER.DBF.....Customer file ------------ STORE 'CUSTCODE C5 ' TO FIELD1 && CUSTOMER ID NUMBER STORE 'CUSTNAME C35 ' TO FIELD2 && NAME STORE 'CUSTADD1 C30 ' TO FIELD3 && ADDRESS STORE 'CUSTCITY C20 ' TO FIELD4 && CITY STORE 'CUSTSTATE C2 ' TO FIELD5 && STATE STORE 'CUSTZIP C10 ' TO FIELD6 && ZIPCODE STORE 'CUSTPHONE C10 ' TO FIELD7 && HOME PHONE STORE 'CUSTPHONE2 C10 ' TO FIELD8 && WORK OR OTHER PHONE STORE 'CUSTLEVEL C1 ' TO FIELD9 && PROFIT LEVEL STORE 'CUSTDISC N5 2' TO FIELD10 && DISCOUNT AMOUNT STORE 'CUSTERMS C15 ' TO FIELD11 && NORMAL TERMS STORE 'CUSTAXNO C11 ' TO FIELD12 && TAX ID NUMBER STORE 'CUSTYPE C1 ' TO FIELD13 && DO THEY HAVE A VEHICLE VEHICLE.DBF.....Customer vehicles ----------- STORE 'VEHCODE C5 ' TO FIELD1 && CUSTOMER ID NUM STORE 'VEHIDNUM C5 ' TO FIELD2 && UNIQUE VEHICLE ID NUM STORE 'VEHNAME C20 ' TO FIELD3 && DESCRIPTION STORE 'VEHLIS C10 ' TO FIELD4 && LISCENSE STORE 'VEHMILE C6 ' TO FIELD5 && MILEAGE STORE 'VEHVIN C20 ' TO FIELD6 && VIN NUMBER STORE 'VEHENG C4 ' TO FIELD7 && ENGINE SIZE VENDOR.DBF.....Vendor info ---------- STORE 'VENDCODE C5 ' TO FIELD1 && VENDOR ID NUM STORE 'VENDNAME C30 ' TO FIELD2 && VENDOR NAME STORE 'VENDADD C30 ' TO FIELD3 && VENDOR ADDRESS STORE 'VENDCITY C20 ' TO FIELD4 && VENDOR CITY STORE 'VENDSTATE C2 ' TO FIELD5 && VENDOR STATE STORE 'VENDZIP C10 ' TO FIELD6 && ZIP STORE 'VENDPHONE C10 ' TO FIELD7 && PHONE STORE 'VENDTERMS C20 ' TO FIELD8 && TERMS STORE 'VENDCONTA C20 ' TO FIELD9 && WHO TO CONTACT STORE 'VENDFAX C10 ' TO FIELD10 && FAX NUMBER INVOICE.DBF.....Invoice data ----------- STORE 'INVNUM C5 ' TO FIELD1 && INVOICE NUMBER STORE 'INVDATE D8 ' TO FIELD2 && INVOICE DATE STORE 'INVCCODE C5 ' TO FIELD3 && CUSTOMER CODE STORE 'INVTAXABLE N9 2' TO FIELD4 && TAXABLE TOTAL STORE 'INVNOTAX N9 2' TO FIELD5 && NON TAXABLE TOTAL STORE 'INVTAX N8 6' TO FIELD6 && CURRENT SALES TAX RATE STORE 'INVVIDNUM C5 ' TO FIELD7 && WHAT VEHICLE STORE 'INVMILE C10 ' TO FIELD8 && CURRENT MILEAGE STORE 'INVPAID L1 ' TO FIELD9 && UNTIL PAID-ALLOW EDITING STORE 'INVEST C1 ' TO FIELD10 && (I)NVOICE - (E)STIMATE - (B)AD DEBT STORE 'INVEMP C9 ' TO FIELD11 && RO/PO NUMBER STORE 'INVSHOP N5 2' TO FIELD12 && SHOP SUPPLIES STORE 'INVCOM C1 ' TO FIELD13 && WORKING - COMPLETED STORE 'INVENVIRO N5 2' TO FIELD14 && ENVIRONMENTAL FEES STORE 'INVORIG C5 ' TO FIELD15 && ORIGINAL INVOICE FOR WARRANTY INVNODE.DBF..... Line items ----------- STORE 'NODEINVNUM C5 ' TO FIELD1 && INVOICE NUMBER STORE 'NODEPTCODE C11 ' TO FIELD2 && UNIQUE MANUF OR CUSTOEMR NUMBER STORE 'NODEQUAN N6 2' TO FIELD3 && QUANITY STORE 'NODEPRICE N8 2' TO FIELD4 && CURRENT (CALCULATED/SELLING) PRICE STORE 'NODEEST C1 ' TO FIELD5 && ESTIMATE/INVOICE STORE 'NODECOST N8 2' TO FIELD6 && CURRENT COST OF THIS ITEM STORE 'NODEDATE D8 ' TO FIELD7 && DATE STORE 'NODECUST C5 ' TO FIELD8 && CUSTOMER CODE FOR LAST PRICE CHARGED STORE 'NODEVEND C7 ' TO FIELD9 && VENDOR PAYMENTS.DBF.....Payment information ------------ STORE 'PAYINV C5 ' TO FIELD1 && INVOICE NUMBER STORE 'PAYDATE D8 ' TO FIELD2 && INVOICE DATE STORE 'PAYCUST C5 ' TO FIELD3 && CUSTOMER CODE STORE 'PAYAMOUNT N8 2' TO FIELD4 && AMOUNT PAID STORE 'PAYDIS N8 2' TO FIELD5 && AMOUNT DISCOUNT STORE 'PAYMETHOD C1 ' TO FIELD6 && METHOD OF PAYMENT STORE 'PAYEMP C4 ' TO FIELD7 && EMPLOYEE STORE 'PAYREF C16 ' TO FIELD8 && REFERENCE SERVICE.DBF.....Labor data ----------- STORE 'SERINV C5 ' TO FIELD1 && INVOICE NUMBER STORE 'SERTEXT C60 ' TO FIELD2 && TEXT STORE 'SERTIME N5 2' TO FIELD3 && TIME ALLOWED FOR REPAIRS STORE 'SERCOST N7 2' TO FIELD4 && COST STORE 'SERTECH C4 ' TO FIELD5 && TECH STORE 'SERDATE D8 ' TO FIELD6 && DATE FOR MECH EARNINGS STORE 'SERVEH C5 ' TO FIELD7 && VEHICLE (VEHICLE HISTORY REPORT) STORE 'SERCUST C5 ' TO FIELD8 && CUSTOMER - LABELS (MINOR DUPLICATION) STORE 'SERCODE C6 ' TO FIELD9 && SERVICE CODE - LABELS STORE 'SERTAX L1 ' TO FIELD10 && TAXABLE (Y-N) JOBS.DBF.....Predefined jobs -------- STORE 'JOBCODE C6 ' TO FIELD1 && UNIQUE JOB CODE STORE 'JOBTEXT C60 ' TO FIELD2 && JOB DESCRIPTION STORE 'JOBTIME N5 2' TO FIELD3 && TIME STORE 'JOBCOST N7 2' TO FIELD4 && JOB COST ITMNTX.DBF.....Auto file ---------- STORE 'VMAKE C30 ' TO FIELD1 && CHEVY ETC STORE 'VMODEL C40 ' TO FIELD2 && CAPRICE STORE 'VITEM C11 ' TO FIELD3 && TRANSMISSION STORE 'VYEARS C5 ' TO FIELD4 && VALID YEARS EMPLOYEE.DBF.....Employee data ------------ STORE 'LAST C20 ' TO FIELD1 && LAST NAME STORE 'FIRST C20 ' TO FIELD2 && FIRST NAME STORE 'STREET C30 ' TO FIELD3 && ADDRESS STORE 'CITY C20 ' TO FIELD4 && CITY STORE 'STATE C2 ' TO FIELD5 && STATE STORE 'ZIP C5 ' TO FIELD6 && ZIPCODE STORE 'EMPNUM C4 ' TO FIELD7 && EMPLOYEE NUMBER STORE 'WAGERATE N9 2' TO FIELD8 && RATE OF PAY STORE 'WAGETYPE C1 ' TO FIELD9 && SALARIED OR HOURLY STORE 'PHONE C8 ' TO FIELD10 && PHONE STORE 'SSNUM C9 ' TO FIELD11 && SS NUMBER STORE 'ACTIVE L1 ' TO FIELD12 && CURRENTLY WORKING STORE 'H_DATE D8 ' TO FIELD13 && HIRE DATE STORE 'T_DATE D8 ' TO FIELD14 && TERMINATION DATE STORE 'MARRIED L1 ' TO FIELD15 && MARRIED T-F STORE 'DEP N2 0' TO FIELD16 && NUMBER OF DEPENDENCE STORE 'W_TYPE C2 ' TO FIELD17 && WEEKLY,MONTHLY ETC STORE 'DEPT C8 ' TO FIELD18 && DEPARTMENT STORE 'INSURANCE N6 2' TO FIELD19 && INSURANCE STORE 'MISC N6 2' TO FIELD20 && MISC DEDUCTIONS STORE 'COMISION N5 2' TO FIELD21 && PERCENT COMMISSION STORE 'NOTES M10 ' TO FIELD22 && COMMENTS STORE 'W_HOLD N7 2' TO FIELD23 && ADDITIONAL WH JOBPART.DBF ----------- STORE 'JCODE C6 ' TO FIELD1 && UNIQUE JOB CODE STORE 'JPART C11 ' TO FIELD2 && PART NUMBER STORE 'JQUAN N6 2' TO FIELD3 && QUANTITY REQUIRED INDEX(S) INDEX KEY PARTS.DBF PARTID.NTX && VENDOR PART NUMBER PARTTEXT.NTX && DESCRIPTION PARTCODE.NTX && GROUP CUSTOMER.DBF CUSTCODE.NTX && UNIQUE CUSTOMER CODE CUSTNAME.NTX && CUSTOMER NAME VEH.DBF VEHIDNUM.NTX && SAME AS CUSTOMER ID (CONNECTING FIELD) VEHCODE.NTX && UNIQUE VEHICLE ID NUMBER VEHLIS.NTX && LICENSE NUMBER (USED IN LOOKING US VEHICLES) VENDOR.DBF VENDCODE.NTX && UNIQUE CODE ASSIGNED BY USER INVOICE.DBF INVNUM.NTX && INVOICE NUMBER INVCCODE.NTX && CUSTOMER CODE INVDATE.NTX && INVOICE DATE (USED ON MANY REPORTS) INVNODE.DBF NODENUM.NTX && INVOICE NUMBER NODEPART.NTX && VENDOR PART NUMBER PAYMENTS.DBF PAYINV.NTX && INVOICE NUMBER SERVICE.DBF SERINV.NTX && INVOICE NUMBER SERDATE.NTX && SAME AS INVOICE DATE SERVEH.NTX && UNIQUE VEHICLE CODE (VEHICLE HISTORY) JOBS.DBF JOBCODE.NTX && UNIQUE JOB CODE (BY USER) ITMNTX.DBF VMAKE.NTX && AUTOMOBILE MAKE JOBPART.DBF JCODE.NTX && SAME NUMBER AS JOBCODE IN JOBS.DBF (CONNECTING) EMPLOYEE.DBF EMPLOYEE.NTX && EMPLOYEE ID NUMBER FIRST.NTX && FIRST NAME DEPART.NTX && DEPARTMENT End of file (sc.doc) *-----------------------------------------------------------------------------